--DROP TABLE [dbo].[Logs]

CREATE TABLE [dbo].[Logs](
    [ID] [bigint] IDENTITY(1,1) NOT NULL,
    [TimeStamp] [datetime]  NULL,
    [Level] [nvarchar](50)  NULL,
    [Host] [nvarchar](100)  NULL,
	[RemoteAddr] [nvarchar](100)  NULL,
	[Logger] [nvarchar](100)  NULL,
    [Source] [nvarchar](100)  NULL,   
	[Url] [nvarchar](512)  NULL,  
    [Message] [nvarchar](max)  NULL,
	[Exception] [nvarchar](max)  NULL,
 CONSTRAINT [PK_Logs] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)
WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 
GO



--# for membership login audit logs

CREATE TABLE [dbo].[MembershipLogs](
    [ID] [bigint] IDENTITY(1,1) NOT NULL,
    [TimeStamp] [datetime]  NULL,
    [Level] [nvarchar](50)  NULL,
    [Host] [nvarchar](100)  NULL,
	[RemoteAddr] [nvarchar](100)  NULL,
	[Logger] [nvarchar](100)  NULL,
	[Url] [nvarchar](512)  NULL,  
    [Message] [nvarchar](max)  NULL,
 CONSTRAINT [PK_MembershipLogs] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)
WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 
GO



